Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

Tablepublic.atinterface

Columns

ColumnData TypeNullableDefaultDescription
idintegernot null  
nodeidintegernot null  
ipaddrvarchar(16)not null  
atphysaddrvarchar(12)not null  
statuschar(1)not null  
sourcenodeidintegernot null  
ifindexintegernot null  
lastpolltimetimestamp without time zonenot null  

Primary Key

Primary KeyColumns
pk_atinterfacenodeid, ipaddr, atphysaddr

Indexes

IndexTypeColumns
atinterface_atphysaddr_idx atphysaddr
atinterface_node_ipaddr_idx nodeid, ipaddr
atinterface_nodeid_idx nodeid

Foreign Keys

RelationColumnReferenced Column
public.nodenodeidnodeid

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.